UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNsHa2YS9eukIwzblZRZNYmTZkUV1mr0rFkk9FKnVMU='
WHERE
key_id = '13a6bbb7f2f0f49fc73d2f161f72918601fb270fa054a86b7999fe8a44e24bc3'
AND (
token = 'tNsHa2YS9eukIwzblZRZNYmTZkUV1mr0rFkk9FKnVMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)