UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XLRBnjshfzVY6uSo6eI8Uns2tRIc84KAKmySZxmt3iQ='
WHERE
key_id = '47dd685be836ea6a0e4964928e6cff9cc860b548bada5c14683cbebe2852ca5d'
AND (
token = 'XLRBnjshfzVY6uSo6eI8Uns2tRIc84KAKmySZxmt3iQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)