UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3rJYy4gk/thKGUHNdlQmzg8/l/V4AA5Yl0d/cagWKaE='
WHERE
key_id = 'a54f06c62bb45d4c795d433434886954519a7a7dea27b78e1b5a5292532e7528'
AND (
token = '3rJYy4gk/thKGUHNdlQmzg8/l/V4AA5Yl0d/cagWKaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)