UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0uQEnzIXktDWDErrUGe+E4H3x46IKogLynCONjoUw4='
WHERE
key_id = 'c3ad30345c9da05bb6a2c7af2297ae21fb6e810535be67144ef9fd86af7301c0'
AND (
token = 'X0uQEnzIXktDWDErrUGe+E4H3x46IKogLynCONjoUw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)