UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'obJTH4E5hq0jqWDivZ7Fymylc6rUpL8TVXFjbwS7uUc='
WHERE
key_id = '678702b9d15b89a9d01398a2187d6b227114feab53eff423b46add0646191366'
AND (
token = 'obJTH4E5hq0jqWDivZ7Fymylc6rUpL8TVXFjbwS7uUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)