UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BVcRU2F7RUM4X10WOSYsDFclZxT8HxQ62Ys8HkaCctI='
WHERE
key_id = 'd6932a5df64200da1d227b171421cf19edae883128a3683cfb4621ec9ee80a17'
AND (
token = 'BVcRU2F7RUM4X10WOSYsDFclZxT8HxQ62Ys8HkaCctI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)