UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmCeFZ42jzbCEs1RC69POYFDW9znSZ/xUf4gK6zRbxE='
WHERE
key_id = 'e08d48afad393d8d400c180ae50d98d7d8b3c4dd56e7914b3b087354746fc567'
AND (
token = 'VmCeFZ42jzbCEs1RC69POYFDW9znSZ/xUf4gK6zRbxE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)