UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qdX+oJvLqKzKsW35v9XnYtFgw3dQqkydIh6Y5NQdqXs='
WHERE
key_id = '1e09c1d251bf1b03d32c47f7db2db1e7394728113358a84a3deafffab6de5010'
AND (
token = 'qdX+oJvLqKzKsW35v9XnYtFgw3dQqkydIh6Y5NQdqXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)