UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MIGay5bw1rDVh5AbtHPJQmRJvOi50/YnS4w8tWfuFtY='
WHERE
key_id = 'a1dca9544c39d29f31db9cf464978ce20628c7d52438deba4ac30514987b3853'
AND (
token = 'MIGay5bw1rDVh5AbtHPJQmRJvOi50/YnS4w8tWfuFtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)