UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a17U45jCvmGVK7C4ac4v7+eNu+gLeAiiVkz1BaXE3us='
WHERE
key_id = 'f3e3055f0197f64d5a8dff774f7ab299af8636b47e9e335d65586aadff314f29'
AND (
token = 'a17U45jCvmGVK7C4ac4v7+eNu+gLeAiiVkz1BaXE3us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)