UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zy5jb225f+NTdchHJWPjVC9xv4ZAGVVV4yzJgJ8/8+w='
WHERE
key_id = '482856a31f0ac8ef88984937bf16f68c84716626df0f2461c4410dd98033f6ba'
AND (
token = 'zy5jb225f+NTdchHJWPjVC9xv4ZAGVVV4yzJgJ8/8+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)