UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aXY6JXnuEPf1muPCqos3tiGJb66rcJZZnf7iAjd/qU='
WHERE
key_id = '4cf04fefaea740d24633f567a07c4104239c609c618816de3e7e6e9a5766b165'
AND (
token = '+aXY6JXnuEPf1muPCqos3tiGJb66rcJZZnf7iAjd/qU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)