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