UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HcNr8cqsnhMQlLK9XXd60fXEWZnB62WHNi3JcpXFII='
WHERE
key_id = '0290c5118b1174085d1032ba4978dd6a0f9787046a4c069c4e1a6e334219128a'
AND (
token = '6HcNr8cqsnhMQlLK9XXd60fXEWZnB62WHNi3JcpXFII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)