UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6NuONulP9DiYoxy3d1dgwB+Fa/XG/1kyIdJpXavcT4g='
WHERE
key_id = 'fdcfcf661c12e715c3f1ff4a38330c8d4fb480d032e14e5f778f85deed019661'
AND (
token = '6NuONulP9DiYoxy3d1dgwB+Fa/XG/1kyIdJpXavcT4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)