UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SMj5QBcFII6swJx5/ABeUCulPNXGJ0AwSp7m82WgyGU='
WHERE
key_id = '9ad31f7626518fd02caa98c8da594ded9816305f7953676a8e4e04cd0f56368d'
AND (
token = 'SMj5QBcFII6swJx5/ABeUCulPNXGJ0AwSp7m82WgyGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)