UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BR1jSfkzE8nx34WFPtF7f35vDG8u+jXQULwLd9xHWig='
WHERE
key_id = 'f629b4b9699fe5d5be0852ed50e5bcd365a31c9e7b5beba436fc31b0ea155301'
AND (
token = 'BR1jSfkzE8nx34WFPtF7f35vDG8u+jXQULwLd9xHWig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)