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