UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1e97QznzQuTqIB3DYDqtz2vzRD62yGYNp1OLjxa+WI='
WHERE
key_id = '3ef755053f737e0aa8c204109f0dfa33c8cea30a6904c28ed4e2f3487733715a'
AND (
token = '/1e97QznzQuTqIB3DYDqtz2vzRD62yGYNp1OLjxa+WI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)