UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NhjtRwrtEHf+WUfdK0WR0d/7dUs9Eggo4U/PfsKPAaA='
WHERE
key_id = 'a31d91258f188db7028c3c3785b6b3f9683f13e427620cbc77c9620a5a407a34'
AND (
token = 'NhjtRwrtEHf+WUfdK0WR0d/7dUs9Eggo4U/PfsKPAaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)