UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0caeF01CJIhzoBoWU9PmQNOoTre10S7YJCbdrNIQJPY='
WHERE
key_id = '3c5f31635111887521aebc27f30f12460f5adcb6b828e32d841d6ec1216f94ae'
AND (
token = '0caeF01CJIhzoBoWU9PmQNOoTre10S7YJCbdrNIQJPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)