UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMbIkjp2iIYvPmapoDVTnv1h9fbGB7PKwuU/2gay4xo='
WHERE
key_id = '6f4a816675fc00f01401f4b67e49a80397714d5f429cf726baaf1cc55f553a1a'
AND (
token = 'BMbIkjp2iIYvPmapoDVTnv1h9fbGB7PKwuU/2gay4xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)