UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UWpgYPefuFpuigs6y/INXmXGKYbf7S5QuWfxjEhydEU='
WHERE
key_id = 'c5cdf6e909590b3a44d88390e4336834c36fb5cfac04d65fbc7145e16e5f00a1'
AND (
token = 'UWpgYPefuFpuigs6y/INXmXGKYbf7S5QuWfxjEhydEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)