UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpLeL6m6LLrl+kxx/MVoNgQjXYf9GQjuEmfVkmXD1Jw='
WHERE
key_id = 'ab0bf75a9179ee545befd9428894b6515862d54a3cb4a35f036685d393c4766d'
AND (
token = 'XpLeL6m6LLrl+kxx/MVoNgQjXYf9GQjuEmfVkmXD1Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)