UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6NIhR32Ggp583RhOJ5ucRBL1hLs6b4i5GDZrnDm8J8='
WHERE
key_id = '18bab41391f6786612d0992c42fc3eca1a2d4ccb1c82d90478c0aae078ba9f94'
AND (
token = 'a6NIhR32Ggp583RhOJ5ucRBL1hLs6b4i5GDZrnDm8J8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)