UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bA1zP9pJbWjGIz+gXf8qAHp2TwAcRkvSEOBrvhrOoU0='
WHERE
key_id = '4b3c299dcfc1257ae1e19762bfd109dcc8fbc78396c9d54b55e2ffd6117f5920'
AND (
token = 'bA1zP9pJbWjGIz+gXf8qAHp2TwAcRkvSEOBrvhrOoU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)