UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GWpvDpkAj1LL8rGhm3QqLeafix0Xu6c9NoAeO09wWO4='
WHERE
key_id = '9d084e681bbcf17246ac4a5a2c2f3dc31af8d8842cc378048fff5804ab3dffe7'
AND (
token = 'GWpvDpkAj1LL8rGhm3QqLeafix0Xu6c9NoAeO09wWO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)