UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '13ca+yP6tTUD1RVSEE3xr+OU9QWnBr0F/T7vZEKNHlw='
WHERE
key_id = '7aefba381a070c4c52e87c9715058aec130ede9bd921048eb251862d3616d7a3'
AND (
token = '13ca+yP6tTUD1RVSEE3xr+OU9QWnBr0F/T7vZEKNHlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)