UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6n/pTvHX1FqH58o3T9nc7rIhhws6qdGMDmBQYS8oK3o='
WHERE
key_id = '3b8fb4e6eddf045ff8a42ff91a3ace7897683e1e64084758136cfe859f661ea3'
AND (
token = '6n/pTvHX1FqH58o3T9nc7rIhhws6qdGMDmBQYS8oK3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)