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