UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QdrF6T7xeO9xjM9sYIoiRCPuFGohX2R8A++UX4IuLUU='
WHERE
key_id = 'dc3f24fdcce6b78775f38324d32e0f5080b05247542fac5352d746a069e4f736'
AND (
token = 'QdrF6T7xeO9xjM9sYIoiRCPuFGohX2R8A++UX4IuLUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)