UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5Y61tkY0Ls4hGJFqLZ2yhmgIpEZADWUfQtO76LKOPU='
WHERE
key_id = '904f6df7de9f2d123ba1935d9f060a000af8793236bd7cfadacb5cd9008ea66c'
AND (
token = 'B5Y61tkY0Ls4hGJFqLZ2yhmgIpEZADWUfQtO76LKOPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)