UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKnRB87Q+kGUZxkk1nNmHarstFJCxxFh7BBouJJ+ABI='
WHERE
key_id = '675a4767848e2416e71c63f88ac84c00da37b46e82d508cc08dcbdf42f201ec1'
AND (
token = 'nKnRB87Q+kGUZxkk1nNmHarstFJCxxFh7BBouJJ+ABI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)