UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhGPaIphH4ddW0WEnjoo8g2Y7kTv6MnMt5VZEp94C0w='
WHERE
key_id = 'd5ecc837f05176e943a4fbe62777acbcc263771b675c126525a798adf2b071d0'
AND (
token = 'BhGPaIphH4ddW0WEnjoo8g2Y7kTv6MnMt5VZEp94C0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)