UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMySVbBMkS5c53Ikvxh9KKI611JOiC+cm5jhilE71cs='
WHERE
key_id = '74bbbcc3c45e892b6ef0b514f934fa3eace9ef9ca49aa17561f91feea4e29786'
AND (
token = 'BMySVbBMkS5c53Ikvxh9KKI611JOiC+cm5jhilE71cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)